The new course brochure July-December 2010 is available online for download
Watch our presentation movie to get an impression of the Oak3 training center.
Course Code
Course Title
# Days
Location
Startdate
Subscribe
OR2069
Oracle : SQL Basics
3
Kontich - Veldkant 35A - 2550 Kontich - Cronos
04-10-2010
Course Overview:
This course provides an introduction to the SQL database language within the context of an Oracle database.
Specific subject areas to be explored and objectives to be reached are: - A summation of relational database principles and an introduction to the Oracle relational database server. - Using the iSQL*Plus web-based database interface and other traditional interfaces. - Writing simple SQL queries and moderately complex SQL queries using various join techniques. - Summarizing, grouping and sorting data. - Advanced query techniques such as correlated subqueries. - Developing simple SQL*Plus reports. - Creating and maintaining database tables. - Taking advantage of new features such as the use of regular expressions. - Moving beyond basic table definitions, consideration of defining the full range of database objects, such as advanced table definitions, indexes, sequences, views and others. - Understanding basic database security and object privileges. - Using the powerful set of built-in SQL functions. - Protecting the database and extending the basic data model using declarative constraints. - Performing advanced SQL queries such as grouping and cube operations and SQL99 join syntax. - Developing complex SQL*Plus reports and using SQL*Plus scripts.
Course Topics:
RELATIONAL DATABASES & SQL - ABOUT RELATIONAL DATABASES - ELEMENTS OF SQL
CHOOSING A SQL & PL/SQL INTERFACE - ABOUT DATABASE CONNECTIONS - ABOUT BIND VARIABLES - USING SQL DEVELOPER - USING SQL*PLUS - USING APPLICATION EXPRESS
BUILDING A SELECT STATEMENT - ABOUT THE SELECT STATEMENT - USING ALIAS NAMES
RESTRICTING DATA WITH THE WHERE CLAUSE - ABOUT LOGICAL OPERATORS - EQUALITY OPERATOR - BOOLEAN OPERATORS - NULL & BETWEEN OPERATORS - IS [NOT] NULL Operator - [NOT] BETWEEN Operator - FINDING TEXT STRINGS - [NOT] LIKE Operator - REGEXP_LIKE() - IN OPERATOR
SORTING DATA WITH THE ORDER BY CLAUSE - ABOUT THE ORDER BY CLAUSE - MULTIPLE COLUMN SORTS - SPECIFYING THE SORT SEQUENCE - ABOUT NULL VALUES WITHIN SORTS - USING COLUMN ALIASES
PSEUDO COLUMNS & FUNCTIONS - USING ROWID - USING ROWNUM - USING THE FUNCTIONS - SYSDATE - USER & UID - USING THE DUAL TABLE - SESSIONTIMEZONE FUNCTION
USING THE SET OPERATORS - ABOUT THE SET OPERATORS - SET OPERATOR EXAMPLES
SUMMARY FUNCTIONS - ABOUT SUMMARY FUNCTIONS - SUMMARY FUNCTIONS WITH DISTINCT
USING SUB-QUERIES - ABOUT SUB-QUERIES - STANDARD SUB-QUERIES - CORRELATED SUB-QUERIES
AGGREGATING DATA WITHIN GROUPS - ABOUT SUMMARY GROUPS - FINDING GROUPS WITHIN THE BASE TABLES - SELECTING DATA FROM THE BASE TABLES - SELECTING GROUPS FROM THE RESULT TABLE
BUILD SIMPLE SQL*PLUS REPORTS - FORMAT COLUMN OUTPUT WITH COLUMN - DEFINING REPORT BREAKS WITH BREAK - PRODUCE SUBTOTALS WITH COMPUTE
USE DATA DEFINITION LANGUAGE TO CREATE & MANAGE TABLES - CREATE TABLE STATEMENT - NOT NULL - DEFAULT - ALTER TABLE STATEMENT - DROP TABLE STATEMENT - SUPPORTIVE STATEMENTS - DESCRIBE - RENAME
USE DATA MANIPULATION LANGUAGE TO MANIPULATE DATA - ABOUT THE INSERT STATEMENT - ABOUT THE DELETE STATEMENT - ABOUT THE UPDATE STATEMENT - ABOUT TRANSACTIONS - ROLLBACK - COMMIT - SAVEPOINT - SET TRANSACTION - TRUNCATE TABLE - COMPLEX TABLE REFERENCES
APPENDIX A - REFERENCE INFORMATION - SQL DDL STATEMENT REFERENCE - SQL DML STATEMENT REFERENCE - SQL TRANSACTION CONTROL STATEMENT REFERENCE - SQL OPERATORS REFERENCE
Course Audience:
The target audience for this course is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this course will be helpful are: - Application designers and developers. - Database administrators. - Business users and non-technical end users.
